The code was derived from work by the DSI. This analysis seeks to model % of tests positive using wastewater Data. This model has logical reasons to be predictive but only finds moderate success when broken down by collection site. Particularly it consistently underpredicts the % positive rate in the P2 district.
The Original R code file can be found in the [pandemic github repository](https://github.com/UW-Madison-DataScience/pandemic/blob/master/wastewater.Rmd).
The Code for this R File can be found in the [Marlin Lee waste Water Work](https://github.com/MarlinRLee/Covid-Waste-Water-Exploration/blob/main/general%20model%20finding.Rmd)
## # A tibble: 3 x 3
## Date CovRatio PMMoVRatio
## <chr> <dbl> <dbl>
## 1 2020-12-15 1.13 2.96
## 2 2020-12-22 0.814 2.66
## 3 2021-02-18 1.30 2.21
## # A tibble: 3 x 3
## Date CovRatio PMMoVRatio
## <chr> <dbl> <dbl>
## 1 2020-10-26 1.80 0.358
## 2 2020-11-16 0.326 0.0883
## 3 2021-02-08 0.645 0.0607
## # A tibble: 3 x 3
## Date CovRatio PMMoVRatio
## <chr> <dbl> <dbl>
## 1 2021-02-04 7.94 0.879
## 2 2020-11-30 3.47 0.913
## 3 2021-02-11 2.08 1.15
## # A tibble: 3 x 3
## Date CovRatio PMMoVRatio
## <chr> <dbl> <dbl>
## 1 2020-11-16 0.326 0.0883
## 2 2020-11-09 0.134 0.566
## 3 2021-02-01 0.126 0.970
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.06071 0.88396 1.01148 1.08913 1.20287 2.95839
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.126 0.703 0.861 1.122 1.112 7.935
Analysis with old data
## # A tibble: 3 x 2
## Date CovRatio
## <chr> <dbl>
## 1 2020-10-26 1.73
## 2 2020-10-06 1.70
## 3 2020-11-23 1.58
## # A tibble: 3 x 2
## Date CovRatio
## <chr> <dbl>
## 1 2020-11-16 0.432
## 2 2020-09-29 0.219
## 3 2020-11-09 0.135
## # A tibble: 3 x 2
## Date CovRatioN1
## <chr> <dbl>
## 1 2020-10-26 1.73
## 2 2020-10-06 1.59
## 3 2020-11-23 1.30
## # A tibble: 3 x 2
## Date CovRatioN1
## <chr> <dbl>
## 1 2020-09-29 0.399
## 2 2020-11-16 0.326
## 3 2020-11-09 0.131
## # A tibble: 3 x 2
## Date CovRatioN2
## <chr> <dbl>
## 1 2020-10-06 1.73
## 2 2020-11-23 1.67
## 3 2020-11-17 0.723
## # A tibble: 3 x 2
## Date CovRatioN2
## <chr> <dbl>
## 1 2020-09-28 0.549
## 2 2020-11-24 0.530
## 3 2020-09-29 0.120
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.1353 0.5588 0.7004 0.8040 0.8177 1.7299
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.1312 0.4889 0.8434 0.8451 1.0915 1.7299
## Min. 1st Qu. Median Mean 3rd Qu. Max. NA's
## 0.1203 0.5490 0.6134 0.7980 0.7233 1.7308 9